package com.zhang.gmallpublishertest.mapper;

import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;

/**
 * @title:
 * @author: zhang
 * @date: 2022/1/10 20:44
 */
public interface ProductStatsMapper {

    @Select("select sum(order_amount) from product_stats where toYYYYMMDD(stt)=#{date}")
    BigDecimal selectGmv(int date);
}
